package com.panda.web.mapper.wechatinfo;

import com.panda.web.entity.wechatinfo.EnshrineJob;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * 岗位收藏Mapper接口
 * 
 * @author cpanda
 * @date 2025-07-19
 */
@Mapper
public interface EnshrineJobMapper extends BaseMapper<EnshrineJob> {
    @Delete("delete from enshrine_job where openid=#{openid} and jo_id=#{joId}")
    void deleteByOpenidAndJobId(@Param("openid") String openid,@Param("joId")  Long joId);
    @Select("select count(*) from enshrine_job where openid=#{openid} and jo_id=#{joId}")
    int findByOpenidAndJobId(@Param("openid") String openid,@Param("joId")  Long joId);
}
